SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[Main_Insert_ImageLocation]
@Id INT, @Type VARCHAR(50), @Movie VARCHAR(250), @Extension VARCHAR(8)
AS
IF (@Type = 'Movie')
BEGIN
	UPDATE dbo.Media_Movie
	SET [Image] = ('../../Content/MediaImages/Movie/' + @Movie + @Extension)
	WHERE Id = @Id
END
SELECT * FROM dbo.Main_Movie
WHERE MovieTitle LIKE '%17 again%'
GO
